import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
df = pd.read_excel('店铺数据_预处理.xlsx')
df1 = df.groupby('均价（元/人）').sum(numeric_only=True)
plt.figure(figsize=(8,5))
sns.set_style(style='darkgrid',rc={'font.sans-serif':'SimHei'})
sns.set_palette('bright')
sns.scatterplot(x=df1.index,y=df1['评价数'])
plt.title('某点评网站店铺均价与评价数的相关性散点图')
plt.show()